Can someone please help me write a simple query "SELECT first_name FROM table_name" using PDO. I want to move away from using mysql_connect. Im working on a php project with mysql. Can you please write for me such a code that i can use THANK YOU

<?php 
    $host="127.0.0.1"; // Host name 
    $username="root";  // Mysql username 
    $password="";      // Mysql password 
    $db_name="microict-intrasys"; // Database name 
    //$id = 5; 

    try { 
        $conn = new PDO('mysql:host={$host};dbname={$db_name}', $username, $password); 
        // you neeeeeed   this--^ and this--^
        $stmt = $conn->prepare('SELECT version FROM system_info'); 
        $stmt->execute(array('id' => $id)); 
        $result = $stmt->fetchAll(); 

        if ( count($result) ) 
        { 
            foreach($result as $row) 
            { 
                print_r($row); 
            } 
        } 
        else 
        { 
            echo "No rows returned."; 
        } 
    } 
    catch(PDOException $e) 
    { 
        echo 'ERROR: ' . $e->getMessage(); 
    } 
?>